#region Using directives
using System;
using System.Data;
using WP.Commons;
#endregion

namespace WP.MF.DataEntity
{

    /*
     * Created by Web Smart Create Code Tool
     * At 11/19/2007
     */

    //=========MRLPriceByCatg  ============================
    [System.ComponentModel.DesignerCategory("Code")]
    public class MRLPriceByCatgDEL : DataSet, IDataEntity
    {
        //=========mRLPriceByCatg ============================
        public const string TABLENAME_MRLPRICEBYCATG = "mRLPriceByCatg";
        public const string RECID = "RecId";
        public const string PRICEDATE = "PriceDate";
        public const string PLNNO = "PlnNo";
        public const string CATGRP1 = "CatGrp1";
        public const string CATGRP2 = "CatGrp2";
        public const string CATGRP3 = "CatGrp3";
        public const string CATGRP4 = "CatGrp4";
        public const string CATGRP5 = "CatGrp5";
        public const string CATGRP6 = "CatGrp6";
        public const string CATGRP7 = "CatGrp7";
        public const string CATGRP8 = "CatGrp8";
        public const string PRICE5 = "Price5";
        public const string PRICE6 = "Price6";
        public const string PRICE7 = "Price7";
        public const string PRICE8 = "Price8";
        public const string PRICE10 = "Price10";
        public const string PRICE12 = "Price12";
        public const string PRICE14 = "Price14";
        public const string PRICE16 = "Price16";
        public const string PRICE18 = "Price18";
        public const string PRICE20 = "Price20";
        public const string PRICE22 = "Price22";
        public const string PRICE24 = "Price24";
        public const string CURNO = "CurNo";
        public const string RATE = "Rate";
        public const string RECSTAMP = "RecStamp";
        private System.Collections.Specialized.NameValueCollection mVarCollection = new System.Collections.Specialized.NameValueCollection();
        public System.Collections.Specialized.NameValueCollection VarCollection
        {
            get { return mVarCollection; }
            set { mVarCollection = value; }
        }

        public MRLPriceByCatgDEL()
        {
            //Create mRLPriceByCatg structure
            CreatemRLPriceByCatgStructure();

        }

        //=========mRLPriceByCatg============================
        private void CreatemRLPriceByCatgStructure()
        {
            DataTable table;
            DataColumnCollection DCC;
            DataColumn DC = new DataColumn();
            table = new DataTable(TABLENAME_MRLPRICEBYCATG);
            DCC = table.Columns;

            DC = new DataColumn(RECID, typeof(System.Int32));
            DCC.Add(DC);

            DC = new DataColumn(PRICEDATE, typeof(System.DateTime));
            DCC.Add(DC);

            DC = new DataColumn(PLNNO, typeof(System.String));
            DC.MaxLength = 6;
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(CATGRP1, typeof(System.String));
            DC.MaxLength = 6;
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(CATGRP2, typeof(System.String));
            DC.MaxLength = 6;
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(CATGRP3, typeof(System.String));
            DC.MaxLength = 6;
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(CATGRP4, typeof(System.String));
            DC.MaxLength = 6;
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(CATGRP5, typeof(System.String));
            DC.MaxLength = 6;
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(CATGRP6, typeof(System.String));
            DC.MaxLength = 6;
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(CATGRP7, typeof(System.String));
            DC.MaxLength = 6;
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(CATGRP8, typeof(System.String));
            DC.MaxLength = 6;
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(PRICE5, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PRICE6, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PRICE7, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PRICE8, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PRICE10, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PRICE12, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PRICE14, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PRICE16, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PRICE18, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PRICE20, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PRICE22, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(PRICE24, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(CURNO, typeof(System.String));
            DC.MaxLength = 2;
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(RATE, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(RECSTAMP, typeof(System.Byte[]));
            DCC.Add(DC);

            this.Tables.Add(table);
        }

    }
}